SUPPORT / SAMPLES & SAS NOTES
Problem Note 40141: Roll_up_to_parent_flg not being honored for statistical balance and statistical flow accounts
 |  |  |  |  |
In SAS® Financial Management release 5.1, when the ROLL_UP_TO_PARENT_FLG is set to "Y" for a statistical flow or a statistical balance account in the GL_ACCOUNT table and then the standard SAS Data Integration Studio jobs are run to load the GL_ACCOUNT_x_TABLEs and to load the GLAccount dimension, the roll up to parent flag is not honored in FM Studio.
Edit the GL_ACCOUNT table so the ROLL_UP_TO_PARENT_FLG is set to "Y" for a statistical flow or a statistical balance account and then run the jobs
- cind_dds_106500_load_gl_account_table
- cind_dds_106510_load_gl_account_assoc_type_table
- cind_dds_106520_load_gl_account_assoc_table
- cind_dds_106530_load_gl_account_nls_table
- solnsvc_3200_load_dimension-GLAccount
To circumvent this problem, replace the existing <etldim.sas.> macro on the data tier machine with the file included in the 'Downloads' tab, above. The default location for the <etldim.sas.> macro is
<drive>:\Program Files\SAS\SASFoundation\9.2\soltnsdata\sasmacro
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Financial Management | Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 for x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 for x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Enterprise 32 bit | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Enterprise x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Professional 32 bit | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Professional x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate 32 bit | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows 7 Ultimate x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| Windows Vista for x64 | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 5.1 | 5.2 | 9.2 TS2M2 | 9.2 TS2M3 | ||